Labels:book | crt screen | hakham | monitor | plant | reckoner | sky OCR: 132 SECTION CHAPTER What happens when modify a worksheet? When you change the contents of any cell in worksheet, all the formulas are recalculated. This automatic reca alculation feature ensures that the results in every cell are accurate for the information currently entered in the worksheet Your worksheet is also automatically updated to reflect any rows or columns that you add, delete or copy within the worksheet. Unless you specify oth- erwise, a cell reference is a relative reference -that is reference that can change from B4 to B3 for example if row deleted and all the data moves up one row If you don't want cell reference to change you can use an absolute refer- ence An absolute reference never changes when you insert rows or copy or move formulas. Understanding when to use absolute ...
